SQL for Data Science

There are many flavors of SQL but most flavors have the same base commands. SQL queries are typed in the following pattern;

SELECT -- <columns> and <column calculations>
FROM -- <table name>
  JOIN -- <table name>
  ON -- <columns to join>
WHERE -- <filter condition on rows>
GROUP BY -- <subsets for column calculations>
HAVING -- <filter conditions on groups>
ORDER BY -- <how the output is returned in sequence>
LIMIT -- <number of rows to return>

Introductory SQL links

• SQL Guide
• SELECT and FROM clauses
• WHERE and comparison operators
• ORDER BY
• Joins
• Aggregations
• GROUP BY

Learn How to Setup SQLite

SQLite